2014-12-17 - 14559.200 - Spec - Liverpool Calculation - Invoice #Billing #invoices #ABAPEXTRACT

SPECIFICATIONS

14559.200 -Spec- Liverpool Calculation - Invoice


Purpose

Update the pricing for Z0DD and Z0MD, along with the calculation of the invoice total in the EDICOM extract.

Admin Info

Purpose
 Update the pricing for Z0DD and Z0MD, along with the calculation of the invoice total in the EDICOM extract.
Requested By
 Daniel Brennan
Spec Created By
 Deepak Yasam
Spec Created Date
 12/17/2014
Spec QA by
 Deepak Yasam
Objects
 V_T683
ZISD_ETI_INVOICE_EXTRACT
Document Status
 WIP


Estimates


Sl.No
 Activity
 Estimation in Hours
1
 Research
 00
2
 Documentation
 04
3
 Development/ Config
 06
4
 Unit test in DEV
 02
5
 Unit test in QUA
 02
6
 Other activity

TOTAL
 14

References

Prior Tickets

[Provide links of prior associated Spec / Break Fix BOSS document(s)]

None

Documents

[Attach any document(s) received for the requirement(s)]

None


Spec Changes

[List the changes made to program after the approval of the original requirement along with the Date on which the change request was received and the name of the initiator]

Sl.
 Change Details
 Requested By
 Requested On
 Notes if any

























Functional Requirement

Purpose/WHY:

[Explain the purpose of the project and the reason why this requirement has come]
To have a new calulation logic for the total amount value at header level in the ETI extract and to change the steps for Z0DD,Z0MD in the Mexico pricing procedure.

In Scope:

[List the activities to be included in scope]
Only the Mexico standard pricing procedure and total amount field logic changes are included.

Out of Scope:

[Out of scope activities]
The Mexico debit pricing procedure and other field changes are not involved.

Solution Summary

[Discuss this section with Requester and get approval prior to beginning work]

1.The Mexico Stnd.pricing procedure ZMEXSP should be changed for the Z0MD and Z0DD pricing condition steps to calculate the value from net value only.
2. The ETI extract program should be changed for the total amount field value with the new logic at header level.Below is the logic.


(Net Value-SUM(Z0DD+Z0MD))+((Net Value-SUM(Z0DD+Z0MD))*Tax Percentage)

For Example:
Net Value
 120825.72
Z0DD
 4228.9
Z0MD
 3020.64
Final Value
 131748.37

(120825.72 – (4228.9 + 3020.64)) + ((120825.72 - (4228.9 + 3020.64))*0.16)
(120825.72 - 7249.54) + ((120825.72-7249.54)*0.16)
113576.18 + 18172.19
131748.37


Test Plan

[List test scenarios/cases to be executed here]

SD.No
 Test Scenario
 Expected Result
SD001
 Consolidated Invoice for Consolidated Customer
 1.The Z0DD and Z0MD values should be calculated on the net value in the sales documents.
2,The total amount field (net value plus tax) should be calculated as per the new logic at header level in the ETI file
SD002
 Individual Invoice for Consolidated Customer
 1.The Z0DD and Z0MD values should be calculated on the net value in the sales documents.
2,The total amount field (net value plus tax) should be calculated as per the new logic at header level in the ETI file
SD003
 Individual Invoice for Non-Consolidated Customer
 1.The Z0DD and Z0MD values should be calculated on the net value in the sales documents.
2,The total amount field (net value plus tax) should be calculated as per the new logic at header level in the ETI file
SD004
 Credit for Consolidated Invoice for Consolidated Customer
 1.The Z0DD and Z0MD values should be calculated on the net value in the sales documents.
2,The total amount field (net value plus tax) should be calculated as per the new logic at header level in the ETI file
SD005
 Return for Consolidated Invoice for Consolidated Customer
 1.The Z0DD and Z0MD values should be calculated on the net value in the sales documents.
2,The total amount field (net value plus tax) should be calculated as per the new logic at header level in the ETI file
SD006
 Credit for Individual Invoice for Consolidated Customer
 1.The Z0DD and Z0MD values should be calculated on the net value in the sales documents.
2,The total amount field (net value plus tax) should be calculated as per the new logic at header level in the ETI file
SD007
 Debit for Individual Invoice for Consolidated Customer
 1.The Z0DD and Z0MD values should be calculated on the net value in the sales documents.
2,The total amount field (net value plus tax) should be calculated as per the new logic at header level in the ETI file
SD008
 Return for Individual Invoice for Consolidated Customer
 1.The Z0DD and Z0MD values should be calculated on the net value in the sales documents.
2,The total amount field (net value plus tax) should be calculated as per the new logic at header level in the ETI file
SD009
 Credit for Individual Invoice for Non-Consolidated Customer
 1.The Z0DD and Z0MD values should be calculated on the net value in the sales documents.
2,The total amount field (net value plus tax) should be calculated as per the new logic at header level in the ETI file
SD010
 Debit for Individual Invoice for Non-Consolidated Customer
 1.The Z0DD and Z0MD values should be calculated on the net value in the sales documents.
2,The total amount field (net value plus tax) should be calculated as per the new logic at header level in the ETI file
SD011
 Return for Individual Invoice for Non-Consolidated Customer
 1.The Z0DD and Z0MD values should be calculated on the net value in the sales documents.
2,The total amount field (net value plus tax) should be calculated as per the new logic at header level in the ETI file


Solution Details

[Provide complete technical details for configuration or programming here]

Configuration:

Before the change the Z0DD is considered from step 152 and Z0MD from step 159. Now we need to consider the base amount for both the condition types from step 152 i.e., Net value and remove the step 159,161 in the pricing procedure. Below is the screenshot of the existing PP.

Before change.jpg
After the change -
After change.jpg

technical :

Issues

[List Issues / Bugs identified in configuration or development]